Basic SQL
Back to Home
01. Video: SQL Introduction
02. Video: The Parch & Posey Database
03. Video + Text: The Parch & Posey Database
04. Quiz: ERD Fundamentals
05. Text: Map of SQL Content
06. Video: Why SQL
07. Video: How Databases Store Data
08. Text + Quiz: Types of Databases
09. Video: Types of Statements
10. Statements
11. Video: SELECT & FROM
12. Your First Queries in SQL Workspace
13. Solution: Your First Queries
14. Formatting Best Practices
15. Video: LIMIT
16. Quiz: LIMIT
17. Solution: LIMIT
18. Video: ORDER BY
19. Quiz: ORDER BY
20. Solutions: ORDER BY
21. Video: ORDER BY Part II
22. Quiz: ORDER BY Part II
23. Solutions: ORDER BY Part II
24. Video: WHERE
25. Quiz: WHERE
26. Solutions: WHERE
27. Video: WHERE with Non-Numeric Data
28. Quiz: WHERE with Non-Numeric
29. Solutions: WHERE with Non-Numeric
30. Video: Arithmetic Operators
31. Quiz: Arithmetic Operators
32. Solutions: Arithmetic Operators
33. Text: Introduction to Logical Operators
34. Video: LIKE
35. Quiz: LIKE
36. Solutions: LIKE
37. Video: IN
38. Quiz: IN
39. Solutions: IN
40. Video: NOT
41. Quiz: NOT
42. Solutions: NOT
43. Video: AND and BETWEEN
44. Quiz: AND and BETWEEN
45. Solutions: AND and BETWEEN
46. Video: OR
47. Quiz: OR
48. Solutions: OR
49. Text: Recap & Looking Ahead
Back to Home
01. Video: SQL Introduction
Introduction
Next Concept